UCF STIG Viewer Logo
Changes are coming to https://stigviewer.com. Take our survey to help us understand your usage and how we can better serve you in the future.
Take Survey

The Oracle RESOURCE_LIMIT parameter should be set to TRUE.


Overview

Finding ID Version Rule ID IA Controls Severity
V-2593 DO3696-ORACLE11 SV-24942r2_rule Medium
Description
The Oracle RESOURCE_LIMIT parameter determines whether resource limits are enforced in database profiles. If Oracle resource limits are disabled, any defined profile limits will be ignored. NOTE: This does not apply to password resources.
STIG Date
Oracle Database 11g Instance STIG 2016-12-14

Details

Check Text ( C-29487r2_chk )
From SQL*Plus:

select value from v$parameter where name = 'resource_limit';

If the value returned is not set to TRUE, this is a Finding.
Fix Text (F-26553r1_fix)
Enable resource limit checking on the database.

From SQL*Plus:

alter system set resource_limit = TRUE scope = both;

The above SQL*Plus command will set the parameter to take effect immediately and permanently at next system startup.